Show All
Remove a hyperlink
Delete a hyperlink and the text or graphic that represents it
- To remove a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and click Clear Contents on the shortcut menu.
- To remove a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.
Deactivate a single hyperlink
- Right-click the hyperlink you want to deactivate, and then click Remove Hyperlink on the shortcut menu.
Deactivate several hyperlinks at once
- Type the number 1 in a blank cell, and right-click the cell.
- Click Copy on the shortcut menu.
- While pressing CTRL, select each hyperlink you want to deactivate.
How?
- To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross
, then release the mouse button.
- Click Paste Special on the Edit menu.
- Under Operation, click Multiply and then click OK.